問題描述
db2 參照完整性問題 (db2 referential integrity problem)
Situation is pretty serious, we have a table in DB2 on AS400 which has defined foreign key to another table, so we are entering record which have regular ID of referenced table so when we enter SQL insert through front end tool everything went fine.
Problem arises when this insert is to be done through java application which uses Spring Framework (only SQL Handler, web services...) so things finish with PreparedStatement using jdbc drivers in jt400.jar. We got message "referential integrity check failed" what is - as we checked - impossible.
Does anyoe have similar experiences? Should we upgrade JTOPEN library? Now there is actual version 6.5, we are using 6.3 in production and are affraid of negative effects of upgrading it to 6.5.
Forgot to mention, restarting Tomcat (app server) has no effect, but if I restart linux box (ubuntu 8.10) everything works fine. Connection to DB is being administered by JNDI.
參考解法
方法 1:
Maybe you are inside a transaction and the data you are going to put is inconsistent, and then a rollback is performed, so you should not see anytinh wrong.